Proposed Local Data Mart Approach for Data Warehouse Architecture
نویسندگان
چکیده
Data warehouses are in use for more than a decade but companies are still finding it difficult to decide on the approach they should take for successful implementation. Data warehouse architecture plays a major role the successful construction of data warehouse. This paper proposes an approach of constructing local data marts at source and integrating them at enterprise level by creating physical data marts to give global view for the analysis. KeywordsData Warehouse Architecture, CIF, ETL, Bus Architecture, Data Mart
منابع مشابه
Developing an Active Data Warehouse System
Although many data warehouse systems have been developed in recent years, the practice of data warehouse is still immature. Most of current systems have some limitations in terms of flexibility, efficiency and scalability. Furthermore, the contents of a data warehouse are becoming a large and messy jungle. It is difficult to maintain and analyze the data. Much research has been done in data mar...
متن کاملImproving the Data Warehouse Architecture Using Design Patterns
Data warehousing is an important part of the enterprise information system. Business intelligence (BI) relies on data warehouses to improve business performance. Data quality plays a key role in BI. Source data is extracted, transformed, and loaded (ETL) into the data warehouses periodically. The ETL operations have the most crucial impact on the data quality of the data warehouse. ETL-related ...
متن کاملDiretrizes para a Modelagem Incremental de Data Marts
The lack of a detailed comprehensive methodology for Data Warehouse development may be credited to fundamental differences in its requirements when compared to traditional database systems and the various approaches for the Data Warehouse architecture found in the literature. This paper presents a set of guidelines to support the incremental development of a Data Warehouse environment, created ...
متن کاملSherwin-Williams' Data Mart Strategy: Creating Intelligence Across the Supply Chain
Companies can build a data warehouse using a top-down or a bottom-up approach, and each has its advantages and disadvantages. With the top-down approach, a project team first creates an enterprise data warehouse that combines data from across the organization, and end-user applications are developed after the warehouse is in place. This strategy is likely to result in a scaleable data warehouse...
متن کاملEIAW: Towards a Business-Friendly Data Warehouse Using Semantic Web Technologies
Data warehouse is now widely used in business analysis and decision making processes. To adapt the rapidly changing business environment, we develop a tool to make data warehouses more business-friendly by using Semantic Web technologies. The main idea is to make business semantics explicit by uniformly representing the business metadata (i.e. conceptual enterprise data model and multidimension...
متن کامل